CREATE TABLE [dbo].[Spec_stud]
(
[ik_spec] [int] NOT NULL IDENTITY(1, 1),
[Cname_spec] [varchar] (150) COLLATE Cyrillic_General_CI_AS NOT NULL,
[Cshort_spec] [varchar] (10) COLLATE Cyrillic_General_CI_AS NULL,
[Sh_spec] [varchar] (10) COLLATE Cyrillic_General_CI_AS NULL,
[ik_direction] [int] NULL,
[Ik_vip_dep] [int] NULL,
[dDate_spec] [datetime] NULL,
[nN_prikaz] [numeric] (18, 0) NULL,
[spDateExit] [datetime] NULL,
[Cname_qualif] [varchar] (50) COLLATE Cyrillic_General_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Spec_stud] ADD CONSTRAINT [PK_Spec_stud] PRIMARY KEY CLUSTERED  ([ik_spec]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Spec_stud] ADD CONSTRAINT [IX_Spec_stud] UNIQUE NONCLUSTERED  ([Cname_spec], [ik_direction]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Spec_stud] ADD CONSTRAINT [IX_Spec_stud_1] UNIQUE NONCLUSTERED  ([Cshort_spec], [ik_direction]) ON [PRIMARY]
GO
